﻿-- =============================================
-- Author:		GMH
-- Create date: 16/12/2012
-- Description:	
-- =============================================
CREATE PROCEDURE spObtenConfiguracion
	@pnIdLaboratorio INT,
	@pnIdConfiguracion INT
AS
BEGIN
	SET NOCOUNT ON;

    SELECT	IdConfiguracion ,
            IdLaboratorio ,
            Descripcion ,
            Valor1 ,
            Valor2 ,
            Valor3
    FROM	dbo.CfgConfiguracion
    WHERE	IdConfiguracion = @pnIdConfiguracion
    AND		IdLaboratorio	= @pnIdLaboratorio
	
	SET NOCOUNT OFF;
END